Test Data Raw Summary

Dataset statistics

Number of variables	48
Number of observations	2080
Missing cells	13548
Missing cells (%)	13.6%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	780.1 KiB
Average record size in memory	384.1 B

Variable types

CAT	36
NUM	11
UNSUPPORTED	1

Reproduction

Analysis started	2020-06-10 20:13:32.771600
Analysis finished	2020-06-10 20:13:54.678962
Duration	21.91 seconds
Version	pandas-profiling v2.8.0
Command line	`pandas_profiling --config_file config.yaml [YOUR_FILE.csv]`
Download configuration	config.yaml

Warnings

`Average Weekly Wage` has a high cardinality: 464 distinct values	High cardinality
`Claimant Atty Firm Name` has a high cardinality: 195 distinct values	High cardinality
`Claimant Hire Date` has a high cardinality: 1434 distinct values	High cardinality
`Detail Cause` has a high cardinality: 56 distinct values	High cardinality
`Dt Reported to Carrier/TPA` has a high cardinality: 1547 distinct values	High cardinality
`Dt Reported to Employer` has a high cardinality: 1609 distinct values	High cardinality
`Date of Injury/Illness` has a high cardinality: 1640 distinct values	High cardinality
`How Injury Occurred` has a high cardinality: 2077 distinct values	High cardinality
`Injury/Illness City` has a high cardinality: 392 distinct values	High cardinality
`Injury/Illness Postal` has a high cardinality: 550 distinct values	High cardinality
`Detail Cause Code` is highly correlated with `Cause Code`	High correlation
`Cause Code` is highly correlated with `Detail Cause Code`	High correlation
`Claimant Gender Code` is highly correlated with `Claimant Gender`	High correlation
`Claimant Gender` is highly correlated with `Claimant Gender Code`	High correlation
`Claimant Marital Status Code` is highly correlated with `Claimant Marital Status`	High correlation
`Claimant Marital Status` is highly correlated with `Claimant Marital Status Code`	High correlation
`Claimant State Code` is highly correlated with `Claimant State`	High correlation
`Claimant State` is highly correlated with `Claimant State Code`	High correlation
`Detail Cause` is highly correlated with `Cause`	High correlation
`Cause` is highly correlated with `Detail Cause`	High correlation
`Domestic vs. Foreign? Code` is highly correlated with `Domestic vs. Foreign?`	High correlation
`Domestic vs. Foreign?` is highly correlated with `Domestic vs. Foreign? Code`	High correlation
`Employment Status Code` is highly correlated with `Employment Status`	High correlation
`Employment Status` is highly correlated with `Employment Status Code`	High correlation
`Injury/Illness State Code` is highly correlated with `Injury/Illness State`	High correlation
`Injury/Illness State` is highly correlated with `Injury/Illness State Code`	High correlation
`Jurisdiction Code` is highly correlated with `Jurisdiction`	High correlation
`Jurisdiction` is highly correlated with `Jurisdiction Code`	High correlation
`Lost Time or Medical Only? Code` is highly correlated with `Lost Time or Medical Only?`	High correlation
`Lost Time or Medical Only?` is highly correlated with `Lost Time or Medical Only? Code`	High correlation
`OSHA Injury Type` is highly correlated with `Nature of Injury/Illness`	High correlation
`Nature of Injury/Illness` is highly correlated with `OSHA Injury Type` and 2 other fields	High correlation
`Type of Loss` is highly correlated with `Nature of Injury/Illness` and 1 other fields	High correlation
`Type of Loss Code` is highly correlated with `Nature of Injury/Illness` and 1 other fields	High correlation
`Dependent` has 2080 (100.0%) missing values	Missing
`Average Weekly Wage` has 1304 (62.7%) missing values	Missing
`Claimant Age` has 308 (14.8%) missing values	Missing
`Claimant Atty Firm Name` has 1695 (81.5%) missing values	Missing
`Claimant Hire Date` has 109 (5.2%) missing values	Missing
`Claimant Marital Status` has 1742 (83.8%) missing values	Missing
`Claimant Marital Status Code` has 1742 (83.8%) missing values	Missing
`Department Code` has 1095 (52.6%) missing values	Missing
`Injury/Illness Postal` has 513 (24.7%) missing values	Missing
`Number of Dependents` has 2016 (96.9%) missing values	Missing
`Severity Index Code` has 41 (2.0%) missing values	Missing
`Severity Index Code Code` has 41 (2.0%) missing values	Missing
`Reforms_dummy` has 837 (40.2%) missing values	Missing
`Claimant Hire Date` is uniformly distributed	Uniform
`Dt Reported to Carrier/TPA` is uniformly distributed	Uniform
`Dt Reported to Employer` is uniformly distributed	Uniform
`Date of Injury/Illness` is uniformly distributed	Uniform
`How Injury Occurred` is uniformly distributed	Uniform
`Obs_ID` has unique values	Unique
`Dependent` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Time of Injury/Illness` has 368 (17.7%) zeros	Zeros

Obs_ID
Categorical

UNIQUE

Distinct count	2080
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	16.2 KiB

Obs_11933	1
Obs_14895	1
Obs_1019	1
Obs_17662	1
Obs_19086	1
Other values (2075)	2075

Common Values
Length

Value	Count	Frequency (%)
Obs_11933	1	< 0.1%
Obs_14895	1	< 0.1%
Obs_1019	1	< 0.1%
Obs_17662	1	< 0.1%
Obs_19086	1	< 0.1%
Obs_9182	1	< 0.1%
Obs_16226	1	< 0.1%
Obs_11882	1	< 0.1%
Obs_14826	1	< 0.1%
Obs_10357	1	< 0.1%
Other values (2070)	2070	99.5%

Length

Max length	9
Median length	8
Mean length	8.413942308
Min length	6

Dependent
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	2080
Missing (%)	100.0%
Memory size	16.4 KiB

Average Weekly Wage
Categorical

HIGH CARDINALITY
MISSING

Distinct count	464
Unique (%)	59.8%
Missing	1304
Missing (%)	62.7%
Memory size	16.2 KiB

500	47
1,000.00	29
320	25
600	21
150	20
Other values (459)	634

Common Values
Length

Value	Count	Frequency (%)
500	47	2.3%
1,000.00	29	1.4%
320	25	1.2%
600	21	1.0%
150	20	1.0%
1,500.00	16	0.8%
400	16	0.8%
100	16	0.8%
800	10	0.5%
300	9	0.4%
Other values (454)	567	27.3%
(Missing)	1304	62.7%

Length

Max length	8
Median length	3
Mean length	3.900480769
Min length	1

Body Part
Categorical

Distinct count	44
Unique (%)	2.1%
Missing	0
Missing (%)	0.0%
Memory size	16.2 KiB

Finger(s)	173
Knee	168
Low Back Area	162
Other Facial Soft Tissue	158
Ankle	142
Other values (39)	1277

Common Values
Length

Value	Count	Frequency (%)
Finger(s)	173	8.3%
Knee	168	8.1%
Low Back Area	162	7.8%
Other Facial Soft Tissue	158	7.6%
Ankle	142	6.8%
Eye(s)	136	6.5%
Hand	118	5.7%
Lower Leg	87	4.2%
Shoulder(s)	84	4.0%
Wrist	79	3.8%
Other values (34)	773	37.2%

Length

Max length	54
Median length	6
Mean length	10.40673077
Min length	3

Body Part Code
Real number (ℝ_≥0)

Distinct count	44
Unique (%)	2.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	41.11730769230769
Minimum	10
Maximum	90
Zeros	0
Zeros (%)	0.0%
Memory size	16.2 KiB

Quantile statistics

Minimum	10
5-th percentile	14
Q1	33
median	38
Q3	54
95-th percentile	65
Maximum	90
Range	80
Interquartile range (IQR)	21

Descriptive statistics

Standard deviation	17.2116298
Coefficient of variation (CV)	0.4185981712
Kurtosis	0.5356381883
Mean	41.11730769
Median Absolute Deviation (MAD)	15
Skewness	0.4619453535
Sum	85524
Variance	296.2402005

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
36	173	8.3%
53	168	8.1%
42	162	7.8%
18	158	7.6%
55	142	6.8%
14	136	6.5%
35	118	5.7%
54	87	4.2%
38	84	4.0%
34	79	3.8%
Other values (34)	773	37.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
10	3	0.1%
11	2	0.1%
12	5	0.2%
13	17	0.8%
14	136	6.5%

Value	Count	Frequency (%)
90	76	3.7%
66	7	0.3%
65	46	2.2%
63	18	0.9%
62	3	0.1%

Cause
Categorical

HIGH CORRELATION

Distinct count	10
Unique (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	16.2 KiB

Strain or Injury By	553
Fall, Slip or Trip Injury	368
Struck or Injured By	343
Cut, Puncture, Scrape Injured By	255
Miscellaneous Causes	251
Other values (5)	310

Common Values
Length

Value	Count	Frequency (%)
Strain or Injury By	553	26.6%
Fall, Slip or Trip Injury	368	17.7%
Struck or Injured By	343	16.5%
Cut, Puncture, Scrape Injured By	255	12.3%
Miscellaneous Causes	251	12.1%
Striking Against or Stepping on	143	6.9%
Caught In, Under or Between	85	4.1%
Motor Vehicle	53	2.5%
Burn or Scald - Heat or Cold Exposure	28	1.3%
Rubbed or Abraded By	1	< 0.1%

Length

Max length	37
Median length	20
Mean length	23.18269231
Min length	13

Cause Code
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	10
Unique (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1490.4807692307693
Minimum	1000
Maximum	1900
Zeros	0
Zeros (%)	0.0%
Memory size	16.2 KiB

Quantile statistics

Minimum	1000
5-th percentile	1100
Q1	1300
median	1500
Q3	1700
95-th percentile	1900
Maximum	1900
Range	900
Interquartile range (IQR)	400

Descriptive statistics

Standard deviation	234.1785549
Coefficient of variation (CV)	0.1571161197
Kurtosis	-0.814782701
Mean	1490.480769
Median Absolute Deviation (MAD)	200
Skewness	0.1279815304
Sum	3100200
Variance	54839.59559

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1500	553	26.6%
1300	368	17.7%
1700	343	16.5%
1200	255	12.3%
1900	251	12.1%
1600	143	6.9%
1100	85	4.1%
1400	53	2.5%
1000	28	1.3%
1800	1	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1000	28	1.3%
1100	85	4.1%
1200	255	12.3%
1300	368	17.7%
1400	53	2.5%

Value	Count	Frequency (%)
1900	251	12.1%
1800	1	< 0.1%
1700	343	16.5%
1600	143	6.9%
1500	553	26.6%

Claimant Age
Real number (ℝ_≥0)

MISSING

Distinct count	62
Unique (%)	3.5%
Missing	308
Missing (%)	14.8%
Infinite	0
Infinite (%)	0.0%

Mean	40.090857787810386
Minimum	1.0
Maximum	88.0
Zeros	0
Zeros (%)	0.0%
Memory size	16.2 KiB

Quantile statistics

Minimum	1
5-th percentile	22.55
Q1	30
median	40
Q3	49
95-th percentile	60
Maximum	88
Range	87
Interquartile range (IQR)	19

Descriptive statistics

Standard deviation	12.0022201
Coefficient of variation (CV)	0.2993754877
Kurtosis	-0.4956951031
Mean	40.09085779
Median Absolute Deviation (MAD)	9
Skewness	0.2236443653
Sum	71041
Variance	144.0532873

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
39	60	2.9%
41	57	2.7%
30	55	2.6%
46	53	2.5%
38	53	2.5%
42	53	2.5%
27	52	2.5%
40	52	2.5%
25	52	2.5%
26	50	2.4%
Other values (52)	1235	59.4%
(Missing)	308	14.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	2	0.1%
10	2	0.1%
16	1	< 0.1%
17	4	0.2%
18	9	0.4%

Value	Count	Frequency (%)
88	1	< 0.1%
77	1	< 0.1%
74	2	0.1%
72	2	0.1%
71	2	0.1%

Claimant Atty Firm Name
Categorical

HIGH CARDINALITY
MISSING

Distinct count	195
Unique (%)	50.6%
Missing	1695
Missing (%)	81.5%
Memory size	16.2 KiB

TLEVY, STERN & FORD	10
TJ. LEEDS BARROL, IV ATTORNEY AT LAW	8
TSHERMAN, FEDERMAN SAMBUR & LEVINE	7
TGORDON, EDELSTEIN, KREPACK, ET AL	6
TSCHUMMER, ROLBIN, & HURST	6
Other values (190)	348

Common Values
Length

Value	Count	Frequency (%)
TLEVY, STERN & FORD	10	0.5%
TJ. LEEDS BARROL, IV ATTORNEY AT LAW	8	0.4%
TSHERMAN, FEDERMAN SAMBUR & LEVINE	7	0.3%
TGORDON, EDELSTEIN, KREPACK, ET AL	6	0.3%
TSCHUMMER, ROLBIN, & HURST	6	0.3%
TLAW OFFICE OF CHRISTINE T. NELSON	6	0.3%
TLEVY, FORD & WALLACH	6	0.3%
TCARUSO, SPILLANE, LEIGHTON,CONTRASTANO, ULANER & SAVINO	5	0.2%
TLEVY, STERN, & FORD	5	0.2%
TKUSION & CAMPANA	5	0.2%
Other values (185)	321	15.4%
(Missing)	1695	81.5%

Length

Max length	57
Median length	3
Mean length	7.348557692
Min length	3

Claimant Gender
Categorical

HIGH CORRELATION

Distinct count	3
Unique (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	16.2 KiB

Male	1661
Female	411
Uknown	8

Common Values
Length

Value	Count	Frequency (%)
Male	1661	79.9%
Female	411	19.8%
Uknown	8	0.4%

Length

Max length	6
Median length	4
Mean length	4.402884615
Min length	4

Claimant Gender Code
Categorical

HIGH CORRELATION

Distinct count	3
Unique (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	16.2 KiB

M	1661
F	411
U	8

Common Values
Length

Value	Count	Frequency (%)
M	1661	79.9%
F	411	19.8%
U	8	0.4%

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Claimant Hire Date
Categorical

HIGH CARDINALITY
MISSING
UNIFORM

Distinct count	1434
Unique (%)	72.8%
Missing	109
Missing (%)	5.2%
Memory size	16.2 KiB

1/1/2005	14
1/1/2001	8
1/3/2012	8
2/27/2003	7
7/1/2012	6
Other values (1429)	1928

Common Values
Length

Value	Count	Frequency (%)
1/1/2005	14	0.7%
1/1/2001	8	0.4%
1/3/2012	8	0.4%
2/27/2003	7	0.3%
7/1/2012	6	0.3%
3/24/2003	5	0.2%
9/8/2008	5	0.2%
1/7/2013	5	0.2%
4/23/2012	5	0.2%
1/1/2008	5	0.2%
Other values (1424)	1903	91.5%
(Missing)	109	5.2%

Length

Max length	10
Median length	9
Mean length	8.502884615
Min length	3

Claimant Marital Status
Categorical

HIGH CORRELATION
MISSING

Distinct count	3
Unique (%)	0.9%
Missing	1742
Missing (%)	83.8%
Memory size	16.2 KiB

Unmarried, Single, Widowed, Divorced	187
Married	149
Separated	2

Common Values
Length

Value	Count	Frequency (%)
Unmarried, Single, Widowed, Divorced	187	9.0%
Married	149	7.2%
Separated	2	0.1%
(Missing)	1742	83.8%

Length

Max length	36
Median length	3
Mean length	6.259134615
Min length	3

Claimant Marital Status Code
Categorical

HIGH CORRELATION
MISSING

Distinct count	3
Unique (%)	0.9%
Missing	1742
Missing (%)	83.8%
Memory size	16.2 KiB

U	187
M	149
S	2

Common Values
Length

Value	Count	Frequency (%)
U	187	9.0%
M	149	7.2%
S	2	0.1%
(Missing)	1742	83.8%

Length

Max length	3
Median length	3
Mean length	2.675
Min length	1

Claimant State
Categorical

HIGH CORRELATION

Distinct count	44
Unique (%)	2.1%
Missing	0
Missing (%)	0.0%
Memory size	16.2 KiB

California	1186
New York	130
New Mexico	85
Georgia	80
North Carolina	79
Other values (39)	520

Common Values
Length

Value	Count	Frequency (%)
California	1186	57.0%
New York	130	6.2%
New Mexico	85	4.1%
Georgia	80	3.8%
North Carolina	79	3.8%
Texas	71	3.4%
Louisiana	62	3.0%
New Jersey	53	2.5%
Illinois	32	1.5%
Pennsylvania	25	1.2%
Other values (34)	277	13.3%

Length

Max length	15
Median length	10
Mean length	9.4625
Min length	4

Claimant State Code
Categorical

HIGH CORRELATION

Distinct count	44
Unique (%)	2.1%
Missing	0
Missing (%)	0.0%
Memory size	16.2 KiB

CA	1186
NY	130
NM	85
GA	80
NC	79
Other values (39)	520

Common Values
Length

Value	Count	Frequency (%)
CA	1186	57.0%
NY	130	6.2%
NM	85	4.1%
GA	80	3.8%
NC	79	3.8%
TX	71	3.4%
LA	62	3.0%
NJ	53	2.5%
IL	32	1.5%
PA	25	1.2%
Other values (34)	277	13.3%

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Department Code
Real number (ℝ_≥0)

MISSING

Distinct count	21
Unique (%)	2.1%
Missing	1095
Missing (%)	52.6%
Infinite	0
Infinite (%)	0.0%

Mean	12.22741116751269
Minimum	1.0
Maximum	23.0
Zeros	0
Zeros (%)	0.0%
Memory size	16.2 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	6
median	14
Q3	18
95-th percentile	21
Maximum	23
Range	22
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	6.880886977
Coefficient of variation (CV)	0.5627427493
Kurtosis	-1.438882831
Mean	12.22741117
Median Absolute Deviation (MAD)	6
Skewness	-0.1487988687
Sum	12044
Variance	47.34660559

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
21	156	7.5%
8	129	6.2%
17	128	6.2%
3	90	4.3%
6	74	3.6%
18	64	3.1%
2	62	3.0%
14	62	3.0%
11	59	2.8%
1	30	1.4%
Other values (11)	131	6.3%
(Missing)	1095	52.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	30	1.4%
2	62	3.0%
3	90	4.3%
4	11	0.5%
5	12	0.6%

Value	Count	Frequency (%)
23	5	0.2%
22	16	0.8%
21	156	7.5%
20	20	1.0%
19	21	1.0%

Detail Cause
Categorical

HIGH CARDINALITY
HIGH CORRELATION

Distinct count	56
Unique (%)	2.7%
Missing	0
Missing (%)	0.0%
Memory size	16.2 KiB

Strain/Injury by Misc	204
Strain/Injury by Lifting	151
Struck by Falling/Flying Object	130
Fall/Slip, Same Level	127
Misc, Foreign Body in Eye	114
Other values (51)	1354

Common Values
Length

Value	Count	Frequency (%)
Strain/Injury by Misc	204	9.8%
Strain/Injury by Lifting	151	7.3%
Struck by Falling/Flying Object	130	6.2%
Fall/Slip, Same Level	127	6.1%
Misc, Foreign Body in Eye	114	5.5%
Strike/Step On, Fixed Object	110	5.3%
Cut/Puncture/Scrape, Object Lift/Handled	108	5.2%
Misc, Other	104	5.0%
Fall/Slip, Misc	87	4.2%
Cut/Puncture/Scrape, Hand Tool	67	3.2%
Other values (46)	878	42.2%

Length

Max length	40
Median length	25
Mean length	25.66538462
Min length	9

Detail Cause Code
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	56
Unique (%)	2.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	54.09278846153846
Minimum	1
Maximum	99
Zeros	0
Zeros (%)	0.0%
Memory size	16.2 KiB

Quantile statistics

Minimum	1
5-th percentile	13
Q1	29
median	57
Q3	75
95-th percentile	97.1
Maximum	99
Range	98
Interquartile range (IQR)	46

Descriptive statistics

Standard deviation	27.02425373
Coefficient of variation (CV)	0.499590694
Kurtosis	-1.20231525
Mean	54.09278846
Median Absolute Deviation (MAD)	26
Skewness	-0.09761052961
Sum	112513
Variance	730.3102895

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
60	204	9.8%
56	151	7.3%
75	130	6.2%
29	127	6.1%
87	114	5.5%
68	110	5.3%
17	108	5.2%
99	104	5.0%
31	87	4.2%
16	67	3.2%
Other values (46)	878	42.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	12	0.6%
3	1	< 0.1%
4	3	0.1%
5	6	0.3%

Value	Count	Frequency (%)
99	104	5.0%
97	52	2.5%
94	1	< 0.1%
90	16	0.8%
87	114	5.5%

Domestic vs. Foreign?
Categorical

HIGH CORRELATION

Distinct count	2
Unique (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	16.2 KiB

Domestic	2061
Foreign	19

Common Values
Length

Value	Count	Frequency (%)
Domestic	2061	99.1%
Foreign	19	0.9%

Length

Max length	8
Median length	8
Mean length	7.990865385
Min length	7

Domestic vs. Foreign? Code
Categorical

HIGH CORRELATION

Distinct count	2
Unique (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	16.2 KiB

D	2061
F	19

Common Values
Length

Value	Count	Frequency (%)
D	2061	99.1%
F	19	0.9%

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Dt Reported to Carrier/TPA
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count	1547
Unique (%)	74.4%
Missing	0
Missing (%)	0.0%
Memory size	16.2 KiB

3/15/2011	5
10/2/2007	5
11/3/2008	5
3/24/2010	4
5/26/2010	4
Other values (1542)	2057

Common Values
Length

Value	Count	Frequency (%)
3/15/2011	5	0.2%
10/2/2007	5	0.2%
11/3/2008	5	0.2%
3/24/2010	4	0.2%
5/26/2010	4	0.2%
10/22/2003	4	0.2%
1/27/2012	4	0.2%
10/18/2013	4	0.2%
3/7/2006	4	0.2%
4/4/2012	4	0.2%
Other values (1537)	2037	97.9%

Length

Max length	10
Median length	9
Mean length	8.948076923
Min length	8

Dt Reported to Employer
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count	1609
Unique (%)	77.8%
Missing	13
Missing (%)	0.6%
Memory size	16.2 KiB

10/17/2013	5
10/24/2007	5
4/20/2001	4
8/3/2011	4
7/6/2010	4
Other values (1604)	2045

Common Values
Length

Value	Count	Frequency (%)
10/17/2013	5	0.2%
10/24/2007	5	0.2%
4/20/2001	4	0.2%
8/3/2011	4	0.2%
7/6/2010	4	0.2%
6/22/2012	4	0.2%
6/2/2003	4	0.2%
3/31/2014	4	0.2%
3/14/2011	4	0.2%
2/23/2011	4	0.2%
Other values (1599)	2025	97.4%
(Missing)	13	0.6%

Length

Max length	10
Median length	9
Mean length	8.911538462
Min length	3

Employment Status
Categorical

HIGH CORRELATION

Distinct count	8
Unique (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	16.2 KiB

Unknown/Other	1728
Full-Time	307
Seasonal	20
Part-Time	12
Piece Worker	7
Other values (3)	6

Common Values
Length

Value	Count	Frequency (%)
Unknown/Other	1728	83.1%
Full-Time	307	14.8%
Seasonal	20	1.0%
Part-Time	12	0.6%
Piece Worker	7	0.3%
On Strike	3	0.1%
Disabled	2	0.1%
Retired	1	< 0.1%

Length

Max length	13
Median length	13
Mean length	12.32163462
Min length	7

Employment Status Code
Categorical

HIGH CORRELATION

Distinct count	8
Unique (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	16.2 KiB

7	1728
1	307
8	20
2	12
C	7
Other values (3)	6

Common Values
Length

Value	Count	Frequency (%)
7	1728	83.1%
1	307	14.8%
8	20	1.0%
2	12	0.6%
C	7	0.3%
4	3	0.1%
5	2	0.1%
6	1	< 0.1%

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Date of Injury/Illness
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count	1640
Unique (%)	78.8%
Missing	0
Missing (%)	0.0%
Memory size	16.2 KiB

10/17/2013	5
8/3/2011	5
2/23/2011	4
6/22/2012	4
1/8/2003	4
Other values (1635)	2058

Common Values
Length

Value	Count	Frequency (%)
10/17/2013	5	0.2%
8/3/2011	5	0.2%
2/23/2011	4	0.2%
6/22/2012	4	0.2%
1/8/2003	4	0.2%
2/17/2006	4	0.2%
12/13/2010	4	0.2%
11/7/2005	4	0.2%
6/24/2011	4	0.2%
3/20/2013	4	0.2%
Other values (1630)	2038	98.0%

Length

Max length	10
Median length	9
Mean length	8.940384615
Min length	8

Handling Office Name
Categorical

Distinct count	28
Unique (%)	1.3%
Missing	0
Missing (%)	0.0%
Memory size	16.2 KiB

LOS ANGELE	975
SACRAMENTO	263
DALLAS WC	177
NEW JERSEY	108
CHARLOTTE	78
Other values (23)	479

Common Values
Length

Value	Count	Frequency (%)
LOS ANGELE	975	46.9%
SACRAMENTO	263	12.6%
DALLAS WC	177	8.5%
NEW JERSEY	108	5.2%
CHARLOTTE	78	3.8%
LONG ISLAN	59	2.8%
IN-STATE A	57	2.7%
WC SOUTHEA	56	2.7%
ATLANTA	51	2.5%
ILLINOIS	42	2.0%
Other values (18)	214	10.3%

Length

Max length	10
Median length	10
Mean length	9.675961538
Min length	6

How Injury Occurred
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count	2077
Unique (%)	99.9%
Missing	0
Missing (%)	0.0%
Memory size	16.2 KiB

UNKNOWN	2
WHILE WORKING IN A WOODED - TALL GRASS AREA - EE WAS BITTEN	2
EMPLOYEE WAS WORKING ON SET WHEN HE SUSTAINED AN INSECT BITE	2
CAUGHT L INDEX FINGER IN DESK DRAWER AS CLOSING DRAWER	1
EMPLOYEE WAS LOWERING (UNLOADING) A PALLET ON TAILGATE WHEN	1
Other values (2072)	2072

Common Values
Length

Value	Count	Frequency (%)
UNKNOWN	2	0.1%
WHILE WORKING IN A WOODED - TALL GRASS AREA - EE WAS BITTEN	2	0.1%
EMPLOYEE WAS WORKING ON SET WHEN HE SUSTAINED AN INSECT BITE	2	0.1%
CAUGHT L INDEX FINGER IN DESK DRAWER AS CLOSING DRAWER	1	< 0.1%
EMPLOYEE WAS LOWERING (UNLOADING) A PALLET ON TAILGATE WHEN	1	< 0.1%
WHILE STEPPING OFF LIFT GATE - EE LOST HIS BALANCE AND FELL	1	< 0.1%
WHILE EMPLOYEE MOVING/UNLOADING SCAFFOLD OFF TRUCK HE FELL B	1	< 0.1%
EMPLOYEE WAS WORKING ON SET WHEN HE NOTICED A SMALL LUMP UND	1	< 0.1%
EE JUMPING OUT OF BOAT, HIT BOTTOM OF BOAT WITH R FOOT	1	< 0.1%
WALKING THROUGH DARKENED STAGE, HIT R ANKLE ON STEEL CART	1	< 0.1%
Other values (2067)	2067	99.4%

Length

Max length	60
Median length	60
Mean length	57.67163462
Min length	7

Injury/Illness City
Categorical

HIGH CARDINALITY

Distinct count	392
Unique (%)	18.8%
Missing	0
Missing (%)	0.0%
Memory size	16.2 KiB

LOS ANGELES	308
BURBANK	215
UNKNOWN	207
NEW ORLEANS	97
NEW YORK	51
Other values (387)	1202

Common Values
Length

Value	Count	Frequency (%)
LOS ANGELES	308	14.8%
BURBANK	215	10.3%
UNKNOWN	207	10.0%
NEW ORLEANS	97	4.7%
NEW YORK	51	2.5%
BROOKLYN	48	2.3%
WILMINGTON	42	2.0%
CULVER CITY	38	1.8%
ATLANTA	28	1.3%
AUSTIN	27	1.3%
Other values (382)	1019	49.0%

Length

Max length	19
Median length	8
Mean length	9.078846154
Min length	2

Injury/Illness Postal
Categorical

HIGH CARDINALITY
MISSING

Distinct count	550
Unique (%)	35.1%
Missing	513
Missing (%)	24.7%
Memory size	16.2 KiB

91502	194
95816	55
90038	38
91505	29
90028	26
Other values (545)	1225

Common Values
Length

Value	Count	Frequency (%)
91502	194	9.3%
95816	55	2.6%
90038	38	1.8%
91505	29	1.4%
90028	26	1.2%
91608	25	1.2%
91504	24	1.2%
90001	24	1.2%
90232	21	1.0%
90009	20	1.0%
Other values (540)	1111	53.4%
(Missing)	513	24.7%

Length

Max length	9
Median length	5
Mean length	4.495192308
Min length	3

Injury/Illness State
Categorical

HIGH CORRELATION

Distinct count	37
Unique (%)	1.8%
Missing	1
Missing (%)	< 0.1%
Memory size	16.2 KiB

California	1092
Louisiana	174
New York	171
Georgia	93
North Carolina	75
Other values (32)	474

Common Values
Length

Value	Count	Frequency (%)
California	1092	52.5%
Louisiana	174	8.4%
New York	171	8.2%
Georgia	93	4.5%
North Carolina	75	3.6%
Texas	52	2.5%
Hawaii	48	2.3%
New Mexico	43	2.1%
Michigan	43	2.1%
Illinois	35	1.7%
Other values (27)	253	12.2%

Length

Max length	20
Median length	10
Mean length	9.455769231
Min length	3

Injury/Illness State Code
Categorical

HIGH CORRELATION

Distinct count	37
Unique (%)	1.8%
Missing	1
Missing (%)	< 0.1%
Memory size	16.2 KiB

CA	1092
LA	174
NY	171
GA	93
NC	75
Other values (32)	474

Common Values
Length

Value	Count	Frequency (%)
CA	1092	52.5%
LA	174	8.4%
NY	171	8.2%
GA	93	4.5%
NC	75	3.6%
TX	52	2.5%
HI	48	2.3%
MI	43	2.1%
NM	43	2.1%
IL	35	1.7%
Other values (27)	253	12.2%

Length

Max length	3
Median length	2
Mean length	2.000480769
Min length	2

Jurisdiction
Categorical

HIGH CORRELATION

Distinct count	34
Unique (%)	1.6%
Missing	0
Missing (%)	0.0%
Memory size	16.2 KiB

California	1243
New York	194
Louisiana	130
Georgia	81
North Carolina	77
Other values (29)	355

Common Values
Length

Value	Count	Frequency (%)
California	1243	59.8%
New York	194	9.3%
Louisiana	130	6.2%
Georgia	81	3.9%
North Carolina	77	3.7%
Texas	42	2.0%
Illinois	37	1.8%
New Mexico	34	1.6%
Hawaii	32	1.5%
Pennsylvania	31	1.5%
Other values (24)	179	8.6%

Length

Max length	20
Median length	10
Mean length	9.515384615
Min length	4

Jurisdiction Code
Categorical

HIGH CORRELATION

Distinct count	34
Unique (%)	1.6%
Missing	0
Missing (%)	0.0%
Memory size	16.2 KiB

CA	1243
NY	194
LA	130
GA	81
NC	77
Other values (29)	355

Common Values
Length

Value	Count	Frequency (%)
CA	1243	59.8%
NY	194	9.3%
LA	130	6.2%
GA	81	3.9%
NC	77	3.7%
TX	42	2.0%
IL	37	1.8%
NM	34	1.6%
HI	32	1.5%
PA	31	1.5%
Other values (24)	179	8.6%

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Lost Time or Medical Only?
Categorical

HIGH CORRELATION

Distinct count	2
Unique (%)	0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	16.2 KiB

Medical Only	1581
Lost Time	498

Common Values
Length

Value	Count	Frequency (%)
Medical Only	1581	76.0%
Lost Time	498	23.9%
(Missing)	1	< 0.1%

Length

Max length	12
Median length	12
Mean length	11.27740385
Min length	3

Lost Time or Medical Only? Code
Categorical

HIGH CORRELATION

Distinct count	2
Unique (%)	0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	16.2 KiB

MO	1581
LT	498

Common Values
Length

Value	Count	Frequency (%)
MO	1581	76.0%
LT	498	23.9%
(Missing)	1	< 0.1%

Length

Max length	3
Median length	2
Mean length	2.000480769
Min length	2

Nature of Injury/Illness
Categorical

HIGH CORRELATION

Distinct count	36
Unique (%)	1.7%
Missing	0
Missing (%)	0.0%
Memory size	16.2 KiB

Strain	477
Laceration	341
Specific Injury - All Other	309
Contusion	234
Sprain	144
Other values (31)	575

Common Values
Length

Value	Count	Frequency (%)
Strain	477	22.9%
Laceration	341	16.4%
Specific Injury - All Other	309	14.9%
Contusion	234	11.2%
Sprain	144	6.9%
Foreign Body	102	4.9%
Puncture	94	4.5%
Fracture	82	3.9%
Inflammation	77	3.7%
Infection	31	1.5%
Other values (26)	189	9.1%

Length

Max length	59
Median length	9
Mean length	11.71009615
Min length	4

Nature of Injury/Illness Code
Real number (ℝ_≥0)

Distinct count	36
Unique (%)	1.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	41.31153846153846
Minimum	1
Maximum	91
Zeros	0
Zeros (%)	0.0%
Memory size	16.2 KiB

Quantile statistics

Minimum	1
5-th percentile	10
Q1	32
median	43
Q3	52
95-th percentile	59
Maximum	91
Range	90
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	17.33155895
Coefficient of variation (CV)	0.4195331279
Kurtosis	-0.05355411534
Mean	41.31153846
Median Absolute Deviation (MAD)	9
Skewness	-0.4910521822
Sum	85928
Variance	300.3829356

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
52	477	22.9%
40	341	16.4%
59	309	14.9%
10	234	11.2%
49	144	6.9%
25	102	4.9%
43	94	4.5%
28	82	3.9%
37	77	3.7%
36	31	1.5%
Other values (26)	189	9.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	12	0.6%
2	1	< 0.1%
4	27	1.3%
7	11	0.5%
10	234	11.2%

Value	Count	Frequency (%)
91	5	0.2%
90	15	0.7%
80	8	0.4%
78	3	0.1%
77	1	< 0.1%

Number of Dependents
Real number (ℝ_≥0)

MISSING

Distinct count	5
Unique (%)	7.8%
Missing	2016
Missing (%)	96.9%
Infinite	0
Infinite (%)	0.0%

Mean	1.953125
Minimum	1.0
Maximum	5.0
Zeros	0
Zeros (%)	0.0%
Memory size	16.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	3
95-th percentile	4
Maximum	5
Range	4
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.075405977
Coefficient of variation (CV)	0.5506078603
Kurtosis	0.4923951058
Mean	1.953125
Median Absolute Deviation (MAD)	1
Skewness	1.044102286
Sum	125
Variance	1.156498016

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1	28	1.3%
2	19	0.9%
3	11	0.5%
4	4	0.2%
5	2	0.1%
(Missing)	2016	96.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	28	1.3%
2	19	0.9%
3	11	0.5%
4	4	0.2%
5	2	0.1%

Value	Count	Frequency (%)
5	2	0.1%
4	4	0.2%
3	11	0.5%
2	19	0.9%
1	28	1.3%

OSHA Injury Type
Categorical

HIGH CORRELATION

Distinct count	6
Unique (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	16.2 KiB

Injury	2049
Skin disorder	20
Hearing loss	3
Respiratory condition	3
All other illnesses	3

Common Values
Length

Value	Count	Frequency (%)
Injury	2049	98.5%
Skin disorder	20	1.0%
Hearing loss	3	0.1%
Respiratory condition	3	0.1%
All other illnesses	3	0.1%
Poisoning	2	0.1%

Length

Max length	21
Median length	6
Mean length	6.119230769
Min length	6

OSHA Injury Type Code
Real number (ℝ_≥0)

Distinct count	6
Unique (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.0283653846153846
Minimum	1
Maximum	6
Zeros	0
Zeros (%)	0.0%
Memory size	16.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	1
Maximum	6
Range	5
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.2870681124
Coefficient of variation (CV)	0.2791499176
Kurtosis	195.7724395
Mean	1.028365385
Median Absolute Deviation (MAD)	0
Skewness	13.23643863
Sum	2139
Variance	0.08240810116

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1	2049	98.5%
2	20	1.0%
5	3	0.1%
3	3	0.1%
6	3	0.1%
4	2	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	2049	98.5%
2	20	1.0%
3	3	0.1%
4	2	0.1%
5	3	0.1%

Value	Count	Frequency (%)
6	3	0.1%
5	3	0.1%
4	2	0.1%
3	3	0.1%
2	20	1.0%

Severity Index Code
Categorical

MISSING

Distinct count	7
Unique (%)	0.3%
Missing	41
Missing (%)	2.0%
Memory size	16.2 KiB

No Serious Injury Indicated	2026
Back Injury involving Surgery/Extended Disability	7
Fractured Bone(s)	2
Involves AIDS, Herpes, TSS, Cancer, Other Diseases	1
Fatality	1
Other values (2)	2

Common Values
Length

Value	Count	Frequency (%)
No Serious Injury Indicated	2026	97.4%
Back Injury involving Surgery/Extended Disability	7	0.3%
Fractured Bone(s)	2	0.1%
Involves AIDS, Herpes, TSS, Cancer, Other Diseases	1	< 0.1%
Fatality	1	< 0.1%
Serious Burns	1	< 0.1%
Heart Attack or Cardio-Vascular Accident	1	< 0.1%
(Missing)	41	2.0%

Length

Max length	50
Median length	27
Mean length	26.59278846
Min length	3

Severity Index Code Code
Real number (ℝ_≥0)

MISSING

Distinct count	7
Unique (%)	0.3%
Missing	41
Missing (%)	2.0%
Infinite	0
Infinite (%)	0.0%

Mean	9.981853849926434
Minimum	1.0
Maximum	14.0
Zeros	0
Zeros (%)	0.0%
Memory size	16.2 KiB

Quantile statistics

Minimum	1
5-th percentile	10
Q1	10
median	10
Q3	10
95-th percentile	10
Maximum	14
Range	13
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.3150841379
Coefficient of variation (CV)	0.03156569337
Kurtosis	406.0059397
Mean	9.98185385
Median Absolute Deviation (MAD)	0
Skewness	-16.23497957
Sum	20353
Variance	0.09927801396

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
10	2026	97.4%
7	7	0.3%
9	2	0.1%
6	1	< 0.1%
5	1	< 0.1%
1	1	< 0.1%
14	1	< 0.1%
(Missing)	41	2.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	7	0.3%
9	2	0.1%

Value	Count	Frequency (%)
14	1	< 0.1%
10	2026	97.4%
9	2	0.1%
7	7	0.3%
6	1	< 0.1%

Time of Injury/Illness
Real number (ℝ_≥0)

ZEROS

Distinct count	252
Unique (%)	12.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	988.2278846153846
Minimum	0
Maximum	2358
Zeros	368
Zeros (%)	17.7%
Memory size	16.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	600
median	1030
Q3	1500
95-th percentile	2000
Maximum	2358
Range	2358
Interquartile range (IQR)	900

Descriptive statistics

Standard deviation	649.793849
Coefficient of variation (CV)	0.65753442
Kurtosis	-0.9322108012
Mean	988.2278846
Median Absolute Deviation (MAD)	470
Skewness	-0.157018299
Sum	2055514
Variance	422232.0462

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	368	17.7%
1100	82	3.9%
1000	79	3.8%
1500	74	3.6%
800	61	2.9%
1400	61	2.9%
1600	53	2.5%
830	47	2.3%
1030	46	2.2%
900	46	2.2%
Other values (242)	1163	55.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	368	17.7%
5	1	< 0.1%
10	5	0.2%
14	1	< 0.1%
15	9	0.4%

Value	Count	Frequency (%)
2358	1	< 0.1%
2345	3	0.1%
2330	3	0.1%
2315	1	< 0.1%
2300	16	0.8%

Type of Loss
Categorical

HIGH CORRELATION

Distinct count	2
Unique (%)	0.1%
Missing	4
Missing (%)	0.2%
Memory size	16.2 KiB

Specific Injury	2058
Cumulative Trauma	18

Common Values
Length

Value	Count	Frequency (%)
Specific Injury	2058	98.9%
Cumulative Trauma	18	0.9%
(Missing)	4	0.2%

Length

Max length	17
Median length	15
Mean length	14.99423077
Min length	3

Type of Loss Code
Categorical

HIGH CORRELATION

Distinct count	2
Unique (%)	0.1%
Missing	4
Missing (%)	0.2%
Memory size	16.2 KiB

3	2058
1	18

Common Values
Length

Value	Count	Frequency (%)
3	2058	98.9%
1	18	0.9%
(Missing)	4	0.2%

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Policy Year
Real number (ℝ_≥0)

Distinct count	15
Unique (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2007.5461538461539
Minimum	2000
Maximum	2014
Zeros	0
Zeros (%)	0.0%
Memory size	16.2 KiB

Quantile statistics

Minimum	2000
5-th percentile	2001
Q1	2004
median	2008
Q3	2011
95-th percentile	2014
Maximum	2014
Range	14
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	4.240234755
Coefficient of variation (CV)	0.00211214808
Kurtosis	-1.207004565
Mean	2007.546154
Median Absolute Deviation (MAD)	4
Skewness	-0.1583360318
Sum	4175696
Variance	17.97959078

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2011	191	9.2%
2013	186	8.9%
2012	163	7.8%
2010	153	7.4%
2005	152	7.3%
2004	150	7.2%
2007	132	6.3%
2008	131	6.3%
2009	129	6.2%
2014	129	6.2%
Other values (5)	564	27.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2000	102	4.9%
2001	101	4.9%
2002	125	6.0%
2003	125	6.0%
2004	150	7.2%

Value	Count	Frequency (%)
2014	129	6.2%
2013	186	8.9%
2012	163	7.8%
2011	191	9.2%
2010	153	7.4%

Reforms_dummy
Categorical

MISSING

Distinct count	3
Unique (%)	0.2%
Missing	837
Missing (%)	40.2%
Memory size	16.2 KiB

California Refom 1	661
California Refom 0	434
California Reform 2	148

Common Values
Length

Value	Count	Frequency (%)
California Refom 1	661	31.8%
California Refom 0	434	20.9%
California Reform 2	148	7.1%
(Missing)	837	40.2%

Length

Max length	19
Median length	18
Mean length	12.03509615
Min length	3

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

First rows

	Obs_ID	Dependent	Average Weekly Wage	Body Part	Body Part Code	Cause	Cause Code	Claimant Age	Claimant Atty Firm Name	Claimant Gender	Claimant Gender Code	Claimant Hire Date	Claimant Marital Status	Claimant Marital Status Code	Claimant State	Claimant State Code	Department Code	Detail Cause	Detail Cause Code	Domestic vs. Foreign?	Domestic vs. Foreign? Code	Dt Reported to Carrier/TPA	Dt Reported to Employer	Employment Status	Employment Status Code	Date of Injury/Illness	Handling Office Name	How Injury Occurred	Injury/Illness City	Injury/Illness Postal	Injury/Illness State	Injury/Illness State Code	Jurisdiction	Jurisdiction Code	Lost Time or Medical Only?	Lost Time or Medical Only? Code	Nature of Injury/Illness	Nature of Injury/Illness Code	Number of Dependents	OSHA Injury Type	OSHA Injury Type Code	Severity Index Code	Severity Index Code Code	Time of Injury/Illness	Type of Loss	Type of Loss Code	Policy Year	Reforms_dummy
0	Obs_20	NaN	NaN	Wrist	34	Strain or Injury By	1500	37.0	NaN	Male	M	1/1/2000	NaN	NaN	California	CA	NaN	Strain/Injury by Repetitive Motion	97	Domestic	D	4/4/2005	2/11/2005	Unknown/Other	7	4/10/2001	LOS ANGELE	EE CLAIMS: CT 1991 -4/10/01 TO BILATERAL HANDS - WRISTS AND	BURBANK	91502	California	CA	California	CA	Lost Time	LT	Carpal Tunnel Syndrome	78	NaN	Injury	1	No Serious Injury Indicated	10.0	0	Cumulative Trauma	1.0	2001	California Refom 1
1	Obs_30	NaN	465	Multiple Lower Extremities	50	Strain or Injury By	1500	45.0	NaN	Male	M	2/10/1996	NaN	NaN	California	CA	NaN	Strain/Injury by Repetitive Motion	97	Domestic	D	10/6/2005	9/28/2005	Full-Time	1	4/1/2003	LOS ANGELE	EE CLAIMS : CT 1990 -04 -01 -03 TO LOW BACK (L) SIDE (L) LEG	BURBANK	91502	California	CA	California	CA	Lost Time	LT	Strain	52	NaN	Injury	1	No Serious Injury Indicated	10.0	0	Specific Injury	3.0	2003	California Refom 1
2	Obs_36	NaN	237	Knee	53	Strain or Injury By	1500	38.0	NaN	Male	M	3/16/2002	NaN	NaN	California	CA	NaN	Strain/Injury by Repetitive Motion	97	Domestic	D	5/17/2006	5/17/2006	Unknown/Other	7	12/6/2002	LOS ANGELE	EMPLOYEE CLAIMS: CT 12/6/01 - 12/6/02 TO LEFT KNEE FROM REPE	BURBANK	91502	California	CA	California	CA	Lost Time	LT	Strain	52	NaN	Injury	1	No Serious Injury Indicated	10.0	0	Specific Injury	3.0	2002	California Refom 1
3	Obs_57	NaN	1,378.00	Multiple Body Parts	90	Fall, Slip or Trip Injury	1300	NaN	NaN	Male	M	2/27/2001	NaN	NaN	California	CA	NaN	Fall/Slip, Different Level	25	Domestic	D	4/17/2001	4/16/2001	Full-Time	1	4/16/2001	LOS ANGELE	WALKING ON PLYWOOD RAMP, RAMP SLIPPED AND HE FELL ON R SIDE.	LAS VEGAS	89101	Nevada	NV	California	CA	Lost Time	LT	Multiple Injury, Physical Only	90	NaN	Injury	1	No Serious Injury Indicated	10.0	730	Specific Injury	3.0	2001	California Refom 0
4	Obs_72	NaN	888	Multiple Body Parts	90	Miscellaneous Causes	1900	26.0	NaN	Male	M	4/3/2001	NaN	NaN	California	CA	NaN	Misc, Other	99	Domestic	D	5/16/2001	4/20/2001	Full-Time	1	4/4/2001	SACRAMENTO	EE ALLEGES R SCAPULA INJURIES OF UNKNOWN CAUSE	UNKNOWN	91502	California	CA	California	CA	Medical Only	MO	Multiple Injury, Physical Only	90	NaN	Injury	1	No Serious Injury Indicated	10.0	0	Specific Injury	3.0	2001	California Refom 0
5	Obs_77	NaN	1,300.00	Other Facial Soft Tissue	18	Struck or Injured By	1700	NaN	NaN	Male	M	9/25/2000	NaN	NaN	California	CA	NaN	Struck by Object Lifted/Handled	79	Domestic	D	5/22/2001	5/4/2001	Full-Time	1	5/4/2001	SACRAMENTO	FOLDING A CLOTHING RACK, IT COLLAPSED AND STRUCK EES HEAD	LAKE ARROWHEAD	92352	California	CA	California	CA	Lost Time	LT	Contusion	10	NaN	Injury	1	No Serious Injury Indicated	10.0	1030	Specific Injury	3.0	2001	California Refom 0
6	Obs_79	NaN	NaN	Hand	35	Caught In, Under or Between	1100	NaN	NaN	Male	M	NaN	NaN	NaN	California	CA	NaN	Caught In/Between, Machinery	10	Domestic	D	5/22/2001	3/15/2001	Full-Time	1	3/15/2001	SACRAMENTO	ELECTRIC WORK CART SLAMMED ON MY HAND	VALENCIA	91355	California	CA	California	CA	Medical Only	MO	Crushing	13	NaN	Injury	1	No Serious Injury Indicated	10.0	1150	Specific Injury	3.0	2001	California Refom 0
7	Obs_81	NaN	735	Multiple Body Parts	90	Strain or Injury By	1500	NaN	NaN	Male	M	6/8/2001	NaN	NaN	California	CA	NaN	Strain/Injury by Jumping	54	Domestic	D	6/11/2001	6/11/2001	Full-Time	1	6/8/2001	LOS ANGELE	EE JUMPED OFF LADDER, FRACTURED R FOOT AND SPRAINED R ANKLE.	LOS ANGELES	91502	California	CA	California	CA	Lost Time	LT	Fracture	28	NaN	Injury	1	No Serious Injury Indicated	10.0	1500	Specific Injury	3.0	2001	California Refom 0
8	Obs_84	NaN	NaN	Multiple Body Parts	90	Miscellaneous Causes	1900	18.0	NaN	Male	M	10/30/2000	NaN	NaN	California	CA	NaN	Misc, Other	99	Domestic	D	6/19/2001	3/15/2001	Unknown/Other	7	3/15/2001	SACRAMENTO	EE CAME INTO WORK FEELING SINUS PRESSURE & NAUSEA	UNKNOWN	91355	California	CA	California	CA	Medical Only	MO	Multiple Injury, Physical Only	90	NaN	Injury	1	No Serious Injury Indicated	10.0	0	Specific Injury	3.0	2001	California Refom 0
9	Obs_85	NaN	1,967.00	Chest	44	Fall, Slip or Trip Injury	1300	NaN	NaN	Male	M	5/21/2001	NaN	NaN	California	CA	NaN	Fall/Slip, Misc	31	Domestic	D	6/27/2001	6/21/2001	Unknown/Other	7	6/21/2001	SACRAMENTO	HANDLING FOOD SUBSTANCE, SLIPPED & FELL ON GREENBED AREA	LOS ANGELES	90001	California	CA	California	CA	Medical Only	MO	Multiple Injury, Physical Only	90	NaN	Injury	1	No Serious Injury Indicated	10.0	1630	Specific Injury	3.0	2001	California Refom 0

Last rows

	Obs_ID	Dependent	Average Weekly Wage	Body Part	Body Part Code	Cause	Cause Code	Claimant Age	Claimant Atty Firm Name	Claimant Gender	Claimant Gender Code	Claimant Hire Date	Claimant Marital Status	Claimant Marital Status Code	Claimant State	Claimant State Code	Department Code	Detail Cause	Detail Cause Code	Domestic vs. Foreign?	Domestic vs. Foreign? Code	Dt Reported to Carrier/TPA	Dt Reported to Employer	Employment Status	Employment Status Code	Date of Injury/Illness	Handling Office Name	How Injury Occurred	Injury/Illness City	Injury/Illness Postal	Injury/Illness State	Injury/Illness State Code	Jurisdiction	Jurisdiction Code	Lost Time or Medical Only?	Lost Time or Medical Only? Code	Nature of Injury/Illness	Nature of Injury/Illness Code	Number of Dependents	OSHA Injury Type	OSHA Injury Type Code	Severity Index Code	Severity Index Code Code	Time of Injury/Illness	Type of Loss	Type of Loss Code	Policy Year	Reforms_dummy
2070	Obs_19369	NaN	NaN	Knee	53	Fall, Slip or Trip Injury	1300	40.0	NaN	Male	M	3/31/2014	NaN	NaN	Georgia	GA	17.0	Fall/Slip, Same Level	29	Domestic	D	8/25/2014	8/23/2014	Unknown/Other	7	8/22/2014	WC SOUTHEA	EE WAS WALKING AND TRIPPED ALONG AND TRIPPED OVER WOOD AND E	FAYETTEVILLE	30214	Georgia	GA	Georgia	GA	Medical Only	MO	Strain	52	NaN	Injury	1	No Serious Injury Indicated	10.0	1500	Specific Injury	3.0	2014	NaN
2071	Obs_19371	NaN	NaN	Low Back Area	42	Strain or Injury By	1500	27.0	NaN	Male	M	7/21/2014	NaN	NaN	North Carolina	NC	22.0	Strain/Injury by Lifting	56	Domestic	D	8/28/2014	8/27/2014	Unknown/Other	7	8/27/2014	WC SOUTHEA	EMPLOYEE WAS LIFTING HEAVY OBJECTS AND SWITCHED TO A LIGHTER	WILMINGTON	28411	North Carolina	NC	North Carolina	NC	Medical Only	MO	Strain	52	NaN	Injury	1	No Serious Injury Indicated	10.0	1300	Specific Injury	3.0	2014	NaN
2072	Obs_19375	NaN	NaN	Thigh	52	Burn or Scald - Heat or Cold Exposure	1000	32.0	NaN	Female	F	8/11/2014	NaN	NaN	Georgia	GA	21.0	Burn/Exposure, Steam/Fluid	5	Domestic	D	9/3/2014	9/3/2014	Unknown/Other	7	9/3/2014	WC SOUTHEA	CLEANING UP KITCHEN AFTER LUNCH, SPILLED BOILING HOT WATER O	ATLANTA	30336	Georgia	GA	Georgia	GA	Medical Only	MO	Burn	4	NaN	Injury	1	No Serious Injury Indicated	10.0	0	Specific Injury	3.0	2014	NaN
2073	Obs_19381	NaN	41	Ankle	55	Strain or Injury By	1500	40.0	NaN	Male	M	8/19/2014	NaN	NaN	Georgia	GA	17.0	Strain/Injury by Misc	60	Domestic	D	9/5/2014	9/4/2014	Unknown/Other	7	9/4/2014	WC SOUTHEA	EMPLOYEE WAS ROOFING SHINGLES, WHEN HE TWISTED HIS RIGHT ANK	SENOIA	NaN	Georgia	GA	Georgia	GA	Medical Only	MO	Sprain	49	NaN	Injury	1	No Serious Injury Indicated	10.0	1145	Specific Injury	3.0	2014	NaN
2074	Obs_19382	NaN	NaN	Low Back Area	42	Fall, Slip or Trip Injury	1300	50.0	NaN	Male	M	7/20/2014	NaN	NaN	Georgia	GA	18.0	Fall/Slip, Same Level	29	Domestic	D	9/8/2014	9/5/2014	Unknown/Other	7	9/5/2014	WC SOUTHEA	EMPLOYEE HAS A POWERED MONITOR ATTACHED TO A CABLE. WHEN THE	ATLANTA	30315	Georgia	GA	Georgia	GA	Medical Only	MO	Strain	52	NaN	Injury	1	No Serious Injury Indicated	10.0	0	Specific Injury	3.0	2014	NaN
2075	Obs_19389	NaN	NaN	Other Facial Soft Tissue	18	Fall, Slip or Trip Injury	1300	48.0	NaN	Female	F	9/2/2014	NaN	NaN	Georgia	GA	17.0	Fall/Slip, Misc	31	Domestic	D	9/10/2014	9/10/2014	Unknown/Other	7	9/10/2014	WC SOUTHEA	MEDIC WAS CALLED TO THE MILL FOR PAINTER WHO HAD FALLEN. PAT	FAYETTEVILLE	30214	Georgia	GA	Georgia	GA	Medical Only	MO	Contusion	10	NaN	Injury	1	No Serious Injury Indicated	10.0	945	Specific Injury	3.0	2014	NaN
2076	Obs_19392	NaN	NaN	Foot	56	Struck or Injured By	1700	25.0	NaN	Female	F	9/2/2014	NaN	NaN	Georgia	GA	14.0	Struck by Object Lifted/Handled	79	Domestic	D	9/11/2014	9/11/2014	Unknown/Other	7	9/10/2014	WC SOUTHEA	WHILE PUSHING CARTS ONE ROLLED OVER HER FOOT. ANDREA FLADER,	WILLIAMSON	30292	Georgia	GA	Georgia	GA	Medical Only	MO	Sprain	49	NaN	Injury	1	No Serious Injury Indicated	10.0	2130	Specific Injury	3.0	2014	NaN
2077	Obs_19411	NaN	NaN	Knee	53	Strain or Injury By	1500	41.0	NaN	Male	M	6/4/2014	NaN	NaN	Georgia	GA	17.0	Strain/Injury by Misc	60	Domestic	D	9/24/2014	9/24/2014	Unknown/Other	7	9/16/2014	WC SOUTHEA	EMPLOYEE WAS WALKING ON LOOSE GRAVEL WHEN HE TWISTED HIS RIG	ATLANTA	30316	Georgia	GA	Georgia	GA	Medical Only	MO	Strain	52	NaN	Injury	1	No Serious Injury Indicated	10.0	1000	Specific Injury	3.0	2014	NaN
2078	Obs_19424	NaN	NaN	Toe(s)	57	Struck or Injured By	1700	35.0	NaN	Male	M	7/14/2014	NaN	NaN	Maryland	MD	17.0	Struck by Object Lifted/Handled	79	Domestic	D	9/30/2014	9/30/2014	Unknown/Other	7	9/30/2014	WC SOUTHEA	MOVING WALL AND THE WALL CAME DOWN CRUSHING EE TOE. PRODUCTI	COLUMBIA	21046	Maryland	MD	Maryland	MD	Medical Only	MO	Crushing	13	NaN	Injury	1	No Serious Injury Indicated	10.0	1420	Specific Injury	3.0	2014	NaN
2079	Obs_19495	NaN	NaN	Knee	53	Fall, Slip or Trip Injury	1300	47.0	NaN	Male	M	1/1/2014	NaN	NaN	Virginia	VA	18.0	Fall/Slip, Same Level	29	Domestic	D	11/10/2014	11/7/2014	Unknown/Other	7	11/7/2014	WC SOUTHEA	EE WAS PUSHING SOUND CART IN WOODS WHEN HE TRIPPED ON A TREE	RICHMOND	23226	Virginia	VA	Virginia	VA	NaN	NaN	Sprain	49	NaN	Injury	1	No Serious Injury Indicated	10.0	1700	Specific Injury	3.0	2014	NaN

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows